You are here: Reports > BI Reporting > BI Reporting Data Extraction

BI Reporting Data Extraction

BI Reporting Data Extraction enables you to access and use BI Reporting data with third party software. This is something you would typically do if you need to retrieve more data than is currently allowed by BI Reporting for reports (65,000 rows). Data Extract enables you to retrieve a full data set for further processing in a third party system, or for backup purposes. The BI Reporting Data Extraction enables you to:

This feature is intended for Administrators who are responsible for analytics or for moving data from one product to another. This is not a feature most BI Reporting Administrators need to use. Users with Co-Owner permissions are automatically granted the User Permission necessary for using this feature. You can also manually grant this permission to other Users who need access to the ability to run full data extractions. See BI Reporting User Permissions for information on the User Permission.

Running a Data Extraction

 

The Output tab on the BI Reporting setup page has been updated for use with this feature. The ability to output BI Reports to other formats has not changed, but is now referred to as a Standard extraction.

Select the Data Set you want from the drop-down list:

Note: Sample Data Sets cannot be scheduled.

Note: The maximum amount of time LearnCenter allows for data to be extracted is 6 hours. After that, the extraction is terminated. This limit has been imposed because some extractions can involve large numbers of complicated calculations that impose a drag on system performance. In cases where the time limit is exceeded, a partial data extract is still returned.

You can view the history of data extracts run for any report on the Report History page. See Viewing BI Reporting Report Historyfor complete details on accessing and using this page.

Notice that each extraction file type has its own icon. Clicking on the Last Run links enable you to download the zip file for that particular extraction.

When files are extracted they are compressed ZIP files. Save files to your designated location.

If a warning icon ( ) displays next to an item in the Report History, it indicates that an extraction did not complete. Clicking the icon displays information about why it did not complete, along with tips for improving the extraction the next time you run it.

Cancelling Data Extractions

You can cancel an extraction that is already running if you need to. For example, perhaps you selected the wrong output file type and want to change it. To cancel the first request and start a new one, and attempt to run the report again. The following message displays.

Click Continue to cancel the extraction.

You can only run one extraction at time. This message alerts you to any previous extractions.This is a standard note.

Scheduling Data Extractions

Both Standard and Full data extractions can be scheduled. Sample data must be run manually at the time you need it.

See Scheduling BI Reporting Reports for complete instructions on scheduling reports.

 

Related Topics IconRelated Topics

 

Copyright © 2010-2015, Oracle and/or its affiliates. All rights reserved.